UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4oG3hVRuY+bezCtDw1KkC8rgCGmP+C+7aU1F/xvi2MI=' 
WHERE 
  key_id = '58078d7482b85a759dd8f8a3594ce657bca6a0897bdfce9030af1c208584300b' 
  AND (
    token = '4oG3hVRuY+bezCtDw1KkC8rgCGmP+C+7aU1F/xvi2MI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00012