I have got 40% in my BA. Is it worth to pursue MBA for me?

Yes, you can pursue MBA. But you won't get top B-Schools of India as your score is on the lower side. You can get into any MBA college with not much reputation and brand name. You need to work hard to make your MBA count after completing MBA from a tier-3/4 college.