UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1hoUGpcfU4YkGMzJERk1hVoJsWvRMuzUZNSGhbzh/4='
WHERE
key_id = '98806bed4707d7cf909d0ca28afbb15d6286508299b905fc5d6ddb72c69d0fd0'
AND (
token = 'z1hoUGpcfU4YkGMzJERk1hVoJsWvRMuzUZNSGhbzh/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)