UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QbL4n0FuXho9joIlCEtXiJXG5uM0v7B3J4T4vnMIq/A='
WHERE
key_id = '5a53265396f2ec19509b3e1cbe658dbf3c3adbe07031e1430c9399f46f49fe85'
AND (
token = 'QbL4n0FuXho9joIlCEtXiJXG5uM0v7B3J4T4vnMIq/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)