Cosmic expansion wouldn't cool your can, at least directly. (Of course, the can would eventually equilibrate with the cosmic microwave background and thereby cool due to cosmic expansion indirectly.)
Indeed, in the case of a mirrored box that contains photons, those photons won't cool either.
Why not?
The idea that photons "stretch due to the expansion of space" is kind of misleading. The fact that distant objects are receding from us does not change local particle dynamics. "Expanding space" is itself just a coordinate choice.
Instead, the cosmological redshift is fundamentally just a Doppler shift due to the change in the reference frames of the comoving observers as a photon travels. Comoving observers represent reference frames that follow the Hubble flow of cosmic expansion with no further motion. Since comoving observers are receding from each other, a photon moving from one comoving observer to another will be redshifted in the latter's frame. See Bunn & Hogg (2009) for a much more extended discussion of this point.
Another perspective is that a radiation fluid has a large positive pressure. Imagine containing a bunch of photons inside a mirrored box that is expanding with the Hubble flow. As the box expands, the radiation pressure causes it to do work on the walls, thus reducing its energy. This behavior is exactly an adiabatic cooling process, which conserves $TV^{\gamma-1}$, where $T$ is the temperature of the fluid, $V$ is the volume, and $\gamma=4/3$ is the adiabatic index of a relativistic gas. Thus, $T\propto V^{1-\gamma}= V^{-1/3}$, which is the same $T\propto a^{-1}$ associated with cosmic expansion, where $a$ is the cosmic expansion factor.
Your box full of photons isn't expanding, though. Its volume $V$ is fixed, and hence the temperature $T$ of the radiation is also fixed. (More generally, you could make an expanding box, but there's no reason to make it expand at the same rate as the universe. If it expands at a different rate, then the photons will cool at a different rate.)
Beer is more complicated, since it's a liquid. Still, it should be clear that if the can isn't expanding, there's no reason to expect the contents to cool.