The days of "king corn" could be numbered as climate change brings higher temperatures and water shortages to America's farmland, a new report warned on Wednesday.