UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Sx9edxrRirnzzR496zcsKO8j3/muxs5UB862qxv8Mw4=' 
WHERE 
  key_id = 'fca5bc72c89d61b918abd1dad6b8d1ab86b0a05c08d5b4ef0d7e30c49b8ef360' 
  AND (
    token = 'Sx9edxrRirnzzR496zcsKO8j3/muxs5UB862qxv8Mw4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029