UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dvfT3cxG9D2ArrlmmMXxHLx29ffxbM3ZoQ0THi7fzg8=' 
WHERE 
  key_id = '08c76e8688b762f71439baa3c29e71f30d3c29d7281eb89971801bedea33a415' 
  AND (
    token = 'dvfT3cxG9D2ArrlmmMXxHLx29ffxbM3ZoQ0THi7fzg8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027