UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9t9FC5DuI6R3oF9F6O+/psZOLEQ++Uir0Ir70WoZ8s='
WHERE
key_id = '9e917c3f640a224c5f0d89e4c7d3be2f96426e1b47f4b8c079b909156fd628b3'
AND (
token = 'U9t9FC5DuI6R3oF9F6O+/psZOLEQ++Uir0Ir70WoZ8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)