SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7e5951a1d04e0df71e395ef7f5215dfb9c375345b47c7adb57b8221945e73d32' 
  AND token = '9pJg687wup23eTLnDcaMioPMK0dsV9GJjBrTHJY663Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}