UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wdTJD321UCfRlmLCYwQe33QrrpDp8IMLBGj7r1YO8cs=' 
WHERE 
  key_id = '17c1f9c42832237b5ff8f588ccd386260d9eaa85e3a1b5d8937c7348d94cd59e' 
  AND (
    token = 'wdTJD321UCfRlmLCYwQe33QrrpDp8IMLBGj7r1YO8cs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024