UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxZxiQZodVmDq4FGocq7T/yjE7paZMQeWW6v8HrnSLA='
WHERE
key_id = 'd9c5f8d3a4906a68593ee93b4c8adf4d975b8659f792f40927c6810c3e72be73'
AND (
token = 'nxZxiQZodVmDq4FGocq7T/yjE7paZMQeWW6v8HrnSLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)