UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bACUHc0hLA6X59xp19VhNNe6XHFAlaDZhqNKNlFPMKM='
WHERE
key_id = '5d39b8815fa1e1cef6652cbed94fd1d38ef5a7e16a9bd2ee243d08fb8049d537'
AND (
token = 'bACUHc0hLA6X59xp19VhNNe6XHFAlaDZhqNKNlFPMKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)