UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J9ZIq2uSzpGmjFN7GhJyTs0nkcIkK6KgL+Qasbh4rcQ=' 
WHERE 
  key_id = '9e5465a94bc0c97060e08c4f60c4d998fcd3db4ec90b2fc5c450575529b4f3cf' 
  AND (
    token = 'J9ZIq2uSzpGmjFN7GhJyTs0nkcIkK6KgL+Qasbh4rcQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022