UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6nBxiJmOjsi1bDdkK+ZOq55+Bc5cKzdnZ+7fnCFJi4='
WHERE
key_id = '1b9b6236c679fcd23efb75ae999c68ba9e7d3824d8ecd81fa8b914d2f49b359c'
AND (
token = 'H6nBxiJmOjsi1bDdkK+ZOq55+Bc5cKzdnZ+7fnCFJi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)