UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r9JCLj/hP0S7r/UaBBOskLI4IquMimWRgijy1SgM4HQ=' 
WHERE 
  key_id = '955ecdaeabca1081b1dcfefd3fed86c904f0467ca05d4df33e20ca194dd91be1' 
  AND (
    token = 'r9JCLj/hP0S7r/UaBBOskLI4IquMimWRgijy1SgM4HQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00065