UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29Lt81vUulX2jqYc6VMS1DrJs2QV41Juzv2UjEk8mAE='
WHERE
key_id = 'da977e65443df561c460855394bb53dec8c00d1c65a895a0eb2c6e746f0e405e'
AND (
token = '29Lt81vUulX2jqYc6VMS1DrJs2QV41Juzv2UjEk8mAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)