UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ/mgbaXtyiwV3qkv00lTpi6CfsiLclzmBW9ifLi5GA='
WHERE
key_id = '699fdc7da57097e8f97a992f0362ba08d8359034e222de6efe707b1e87a8979e'
AND (
token = 'zQ/mgbaXtyiwV3qkv00lTpi6CfsiLclzmBW9ifLi5GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)