Spin photovoltaic effect in antiferromagnetic materials: Mechanisms, symmetry constraints, and recent progress