UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0Y0VWWhFmQGlKWS3sLI3N8K7k8aQAR4gBEVOqHGUIak=' 
WHERE 
  key_id = '1580e0a0d4e1097c264c6a6af79214348c7444cdba6c2e4048f9d9c04e0c604f' 
  AND (
    token = '0Y0VWWhFmQGlKWS3sLI3N8K7k8aQAR4gBEVOqHGUIak=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027