UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QbWZthauN6EuB5QJ5o+IA6E7FsjPMc9qbCsJk0epA7U=' 
WHERE 
  key_id = '65bd1aa442f4b7b95c5d3aada84132a68c68c48d606a852a657048696d5401dc' 
  AND (
    token = 'QbWZthauN6EuB5QJ5o+IA6E7FsjPMc9qbCsJk0epA7U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021