Latest results and prospects of the CERN Axion Solar Telescope