UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLby9b9FACOVCWvYV3KtaOzn8o2CTIAFiJoGyYlWaEQ='
WHERE
key_id = 'a8917a52511a344ae086f66ddb37a10dceaac9810e92720f5285ecd5f9d16bfd'
AND (
token = 'ZLby9b9FACOVCWvYV3KtaOzn8o2CTIAFiJoGyYlWaEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)