UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TgC267xN2i1euPKNeRCgGIq6ECmBzEkFYO6Ex/Z44+c='
WHERE
key_id = '8574ab5396d9c81f358bc528024dde1ce6dfbaae7ee029e47720957608b3ead2'
AND (
token = 'TgC267xN2i1euPKNeRCgGIq6ECmBzEkFYO6Ex/Z44+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)