UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VwzocUXiXjXAbfmF0ZumOecY2QzLmT8aAzCcKE8wzRg='
WHERE
key_id = '722bf6cdf3a7a28d209bc7425e62ddb8a7a557237682a22a4dcdfc43c7fb3140'
AND (
token = 'VwzocUXiXjXAbfmF0ZumOecY2QzLmT8aAzCcKE8wzRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)