I have set the WP_DEVELOPMENT_MODE constant in the wp-config.php file for all my local and staging websites and it looks like the problematic transient isn’t generated in the wp_options table so this might be the solution instead of having to delete the transient manually.
/** Set development mode */
define('WP_DEVELOPMENT_MODE', 'all');