Single discount code with tiered spend levels and cart upsell

I want a single discount code (e.g., BFVIP) that automatically applies different fixed discounts based on tiered order spend (e.g., $25 for a specific product/collection, $40 over $149, $90 over $250) and displays cart messaging to encourage customers to reach the next tier.