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