This depends on your coffee powder. If it can be dissolved in room temperature water, you need not even heat up the water or use hot water. But if the coffee powder requires hot water, you will be to use hot water, but in any case, it need not be boiling water (boiling hot). Also, make sure the coffee mixture cools down to room temperature before adding into the cake batter.