UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VSmJsdzrVL4IqW5nWuizgygFN6uaHmP+rylG+DLbM/8='
WHERE
key_id = 'f9ae06e3bf78769ec1f6941b0ab0554c4eff2d9a9aaa1472563d30774bf4e8ee'
AND (
token = 'VSmJsdzrVL4IqW5nWuizgygFN6uaHmP+rylG+DLbM/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)