Nearly second-order asymptotic optimality of sequential change-point detection with one-sample updates