UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFclYPMh5JU3n5zF1Nb6eGo73432maFguWWlwHkcZ9k='
WHERE
key_id = 'cd63434bc7f51f5b65f6d7eaae230e407a32ebc30b01d31c50ac76a6cc853de5'
AND (
token = 'ZFclYPMh5JU3n5zF1Nb6eGo73432maFguWWlwHkcZ9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)