UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLuW33sFmrfhqIPtdF5MlcC+aIpVMkKcCJe2iXgt/zU='
WHERE
key_id = '9be169d913246592ac12ab021cdc0b1967081c1a39c53be589d078e441823e15'
AND (
token = 'BLuW33sFmrfhqIPtdF5MlcC+aIpVMkKcCJe2iXgt/zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)