Validity of Hydrostatic Equilibrium in Galaxy Clusters from Cosmological Hydrodynamical Simulations