UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DN9NOqvlJYIM/D3ENs8K9FWORETfdKswZSlGmSidWQ4='
WHERE
key_id = '3c1dfe223caf6e711c88be8bd35caaf1fec4c02c5b3e9499ecfd04eb09fa61ec'
AND (
token = 'DN9NOqvlJYIM/D3ENs8K9FWORETfdKswZSlGmSidWQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)