Near-Optimal Non-Convex Stochastic Optimization under Generalized Smoothness