UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z2Rz7xXTjIzwzs6qkc5js2lRy3jTR+qAkht8yHjucig=' 
WHERE 
  key_id = '8f30e2118ba3ebe5d2b6dafbf063d18ca2fa4b89cfc7cfa4b3b03934206d3747' 
  AND (
    token = 'Z2Rz7xXTjIzwzs6qkc5js2lRy3jTR+qAkht8yHjucig=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021