MYSQL SELECT records older than 1 year ago

You have to use lower than instead of greater or equals:

$sql = "SELECT * FROM My_Contracte WHERE expired_contract < DATE_SUB(NOW(),INTERVAL 1 YEAR)