UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZw9AJQ8LIEGryGMZAZHGghEtvD5J5JSLjSGzj5tLZY='
WHERE
key_id = '7b927f142711c52975ddd238d8f2a8ef2eb6ecd35be1448aebd474657f2173ea'
AND (
token = 'TZw9AJQ8LIEGryGMZAZHGghEtvD5J5JSLjSGzj5tLZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)