Peter Murrell was led away from court in handcuffs after he was sentenced to more than five years in prison for embezzling more than £400,000 from the Scottish National Party.