Varies by ship if they have one in the room. The mini bar ones aren't very cold. Call the special needs number or fill out the form online to request one. We've had to do that for meds that needed to kept at temp.
https://secure.royalcaribbean.com/allaboutcruising/guestSpecialNeeds.do