A dramatic extra-time comeback has seen former Burnley man Micky Mellon claim a sixth managerial promotion.