Spin photogalvanic effect in two-dimensional collinear antiferromagnets