UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtF7ufbb14QwuAdzgMvSPbJlRn8WRVm8f/VPlCmA/NE='
WHERE
key_id = 'faf2e5fff254af6ddedba814b259359a12f121d423baa54152bf3e05fa5dc4e6'
AND (
token = 'BtF7ufbb14QwuAdzgMvSPbJlRn8WRVm8f/VPlCmA/NE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)