UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bJaJd7rsELCcE5m+n5md75bSEGOiOC9LxoQAua/oPP0=' 
WHERE 
  key_id = '7ddb1d749002700c61b56876af9b5ea34e1aa8c6b13858d9e9599388c7ed7a86' 
  AND (
    token = 'bJaJd7rsELCcE5m+n5md75bSEGOiOC9LxoQAua/oPP0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042