Most probably with a subscription only. You can get it from Family Pharmacy or Al Reem Pharmacy both of which are open 24 hours.

Al Reem Pharmcy is on Al Rayyan Streen
Family pharmacy is has many locations.