The song, which follows up the sugary hit “Espresso,” will appear on the singer’s upcoming album, Short n’ Sweet, out Aug. 23