UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9mt1SkCUGwpLvzGjldEU9rnKPCqODyrCTNG2prQk9jQ=' 
WHERE 
  key_id = '626d19c462c3aa24f63ce644c84c7337a27467e8ae7ab333884b29422d8a3ad5' 
  AND (
    token = '9mt1SkCUGwpLvzGjldEU9rnKPCqODyrCTNG2prQk9jQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00071