New insights on concentration inequalities for self-normalized martingales