UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CMyvVRFgOz+PR02gjy7GLoYHMENSxS6kriFF3eK98ow='
WHERE
key_id = 'fe1bd2d25120a14e0fbb11d8358613fe170cb3582e6a46ec6f2c556b230e9e8f'
AND (
token = 'CMyvVRFgOz+PR02gjy7GLoYHMENSxS6kriFF3eK98ow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)