When I've had that before I would put a wet cool towel on the painful area. Once spent the night laying with my back on the wet towel, woke up and sunburn was almost gone. Guess it's the same idea as running water over a normal burn

Take a bath and pour strong tea, cool of course, over the burn. It works