On integrability of geodesics in near-horizon extremal geometries