SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6b76157987d4f9f0b5a3415abac95fbcfb18c98f58b478efba8d366aa7d07239' 
  AND token = '0fVT+rKCzIDFy9QhQ5d2O2LXJ4C6dCzaXPbHpJEhoTc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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