UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7IIJH2xNifCBpQtecJRrowIbARsjMzrdf6ZL4IkKeig=' 
WHERE 
  key_id = '2f38477c6c1ab8ade57c13f535728082613371c3e8f4356d5bd56a098fca2598' 
  AND (
    token = '7IIJH2xNifCBpQtecJRrowIbARsjMzrdf6ZL4IkKeig=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021