UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8v6q8odU0bnDNzMZWYObJ8xWU6GbgV7YWU3+hRmhOU='
WHERE
key_id = '8e6ce08ee0d7346734e0b85150feae57120ae833e1bcd787063bf62377b7cefb'
AND (
token = 'l8v6q8odU0bnDNzMZWYObJ8xWU6GbgV7YWU3+hRmhOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)