After mindreading Ragnar, the key to that door can be found on one of the horns of the dragon statue you need to climb up. There is nothing special or of high quality in the chest, or the couple crates/barrels in that room.