UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hYKY9JwvfWpypU8hPUDgzGbc9jvHA1HGWInMnDnrsgg=' 
WHERE 
  key_id = '163f97323649d3e1cb11942127a627333708c66b38e964e23609e936ab3d0d34' 
  AND (
    token = 'hYKY9JwvfWpypU8hPUDgzGbc9jvHA1HGWInMnDnrsgg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047