UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42UTdYabS7to9gVLu6phzMjEo+ABZmqEqZ1s5E+ZWiU='
WHERE
key_id = 'd40851ce371021f1d5034a76df207636b59e255c01141b03441380c6729f9d40'
AND (
token = '42UTdYabS7to9gVLu6phzMjEo+ABZmqEqZ1s5E+ZWiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)