A “dangerous” substance abuser who attempted to raid his local petrol station while “off his face” on booze and cocaine has been put behind bars.