UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rIrkK4JM54HoQJcZUbi35rC6xWmUvCOw+7YT8NUuzg='
WHERE
key_id = '9caa1279cdb71f397a943e60dc51c8afef160b6fc450daf70bb5565778063d31'
AND (
token = '9rIrkK4JM54HoQJcZUbi35rC6xWmUvCOw+7YT8NUuzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)