UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiuBF+ZiwXGDb1gj9Xj22lYI0UICtXnU2bE7xhXr7jM='
WHERE
key_id = '5c48924b31056d17bed10b6cbadf3e5afd04ad0b0e0927b67de4af81e56e6f9a'
AND (
token = 'qiuBF+ZiwXGDb1gj9Xj22lYI0UICtXnU2bE7xhXr7jM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)